The Macintosh Demo Applications CD/Apple-MacintoshDemoApplicationsCD-1.0-1992.bin/More Information/GQL V3.0/Open ME! - USA Sales/Open ME! - USA Sales.rsrc/QRY_8372_Order Example

Text File | 1992-01-27 | 593b | 1 lines

100800customer100500order100600placed1400000201140000050114000006011400100301130101000043 000158 000063 000168 10110100000006004'NY'130300000218 000158 000238 000168 00130101000156 000198 000176 000208 101105000010030045000130100000281 000198 000301 000208 001103000010030052000015160010020006placed05order160000020008customer06placed200000250select customer.cust_name, customer.cust_city, customer.cust_state, orders.ord_amount from customer, orders where ((customer.cust_state = 'NY') and ((orders.ord_amount > 5000) and (orders.ord_amount < 20000))) and customer.cust_num = orders.cust_nr ;